package com.ktg.mes.erpUnitMeasure.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ktg.mes.erpUnitMeasure.entity.T6ErpUnitMeasure;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description: 存货分类
 * @Author: jeecg-boot
 * @Date:   2022-08-12
 * @Version: V1.0
 */
public interface T6ErpUnitMeasureMapper extends BaseMapper<T6ErpUnitMeasure> {



	/**
	 * 查询T6 ERP 存货分类
	 * @return
	 */
//	List<T6ErpUnitMeasure> queryList();

	@Select("select top 500 cComunitCode, cComUnitName, cGroupCode, cBarCode, bMainUnit, iChangRate,CONVERT(BIGINT,pubufts) as pubufts  from ComputationUnit where pubufts > #{pubufts}")
	@DS("erp-datasource")
	public List<T6ErpUnitMeasure> queryListByLastPubufts(@Param("pubufts") Long pubufts);

}
